package com.atguigu.gmall.publisher.mapper;

import com.atguigu.gmall.publisher.beans.ProvinceStats;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Author: Felix
 * Date: 2022/4/16
 * Desc: 地区主题统计Mapper层接口
 */
public interface ProvinceStatsMapper {
    //获取某一天地区对应的交易额
    @Select("select province_id,province_name,sum(order_amount) order_amount from province_stats_0925 " +
        " where toYYYYMMDD(stt)=#{date} group by province_id,province_name")
    List<ProvinceStats> selectProvinceStats(Integer date);
}
